Add Method (DatabaseTables Collection)
The Add method is used to add a database table to the report.
Syntax
Sub Add (pLocation As String, [pSubLocation], [pConnectInfo],
[tableType], [pDllName], [pServerName], [pServerType],
[pDatabaseName], [pUserID], [pPassword])
Parameters
Parameter
| Description
|
pLocation
| Specifies the location of the database table that you want to add to the report.
|
[pSubLocation]
| Specifies the sublocation of the database table that you want to add to the report.
|
[pConnectInfo]
| Specifies the connection string.
|
[tableType]
| Specifies the type of database table that you want to add to the report.
|
[pDllName]
| Specifies the DLL name for the database containing the table that you want to add.
|
[pServerName]
| Specifies the database Server Name.
|
[pServerType]
| Specifies the database Server Type.
|
[pDatabaseName]
| Specifies the database (file path and name.ext) containing the table that you want to add.
|
[pUserID]
| Specifies the User's ID.
|
[pPassword]
| Specifies the User's Password.
|
Remarks
- DatabaseTables.Add method is very generic and can be used to add tables to a report from all kinds of data sources (for example, PC Table, SQL Server, ODBC, OLE DB provider, ADO, RDO, DAO Recordset).
- For example:
object.Add "xtreme.mdb", "Customer"